SELECT ORG_MEMBER.CODE psncode,ORG_MEMBER."NAME" psnname,
ORG_UNIT."NAME" deptName,ORG_UNIT.CODE pk_dept,
FORMMAIN_1050.FIELD0044 zscode,NULL zstype,FORMMAIN_1050.FIELD0051 cpmodel,
FORMMAIN_1050.FIELD0052 projectname, FORMMAIN_1050.FIELD0040 psntype,
FORMMAIN_1050.FIELD0042 zycode, FORMMAIN_1050.FIELD0043 zyname,
ORG_POST.CODE pk_post,"TO_CHAR"(FORMMAIN_1050.FIELD0038,'yyyy-MM-dd HH:mm:ss') kskhsj,
FORMMAIN_1050.FIELD0035 kskhcj,
"TO_CHAR"(FORMMAIN_1050.FIELD0034,'yyyy-MM-dd HH:mm:ss') bskhsj,FORMMAIN_1050.FIELD0033 bskhcj,kh."CODE" khfzr,
"TO_CHAR"(FORMMAIN_1050.FIELD0047,'yyyy-MM-dd HH:mm:ss') lintime,"TO_CHAR"(FORMMAIN_1050.FIELD0048,'yyyy-MM-dd HH:mm:ss') ditydate,
FORMMAIN_1050.FIELD0045 linorg, lis."CODE" linpsn,
FORMMAIN_1050.FIELD0049 term_date, FORMMAIN_1050.FIELD0050 vmemo,
FORMMAIN_1050."ID" oa_id, FORMMAIN_1050.FIELD0041 memo1, FORMMAIN_1050.FIELD0040 memo2, '' memo3, '' memo4, '' memo5
FROM COL_SUMMARY 
LEFT JOIN FORMMAIN_1050 ON FORMMAIN_1050."ID" = COL_SUMMARY.FORM_RECORDID
LEFT JOIN ORG_MEMBER ON FORMMAIN_1050.FIELD0002 = ORG_MEMBER."ID"
LEFT JOIN ORG_UNIT ON ORG_MEMBER.ORG_DEPARTMENT_ID = ORG_UNIT."ID"
LEFT JOIN ORG_POST ON ORG_POST."ID" = FORMMAIN_1050.FIELD0012
LEFT JOIN ORG_MEMBER lis ON lis."ID" = FORMMAIN_1050.FIELD0057
LEFT JOIN ORG_MEMBER kh ON kh."ID" = FORMMAIN_1050.FIELD0046
WHERE COL_SUMMARY."ID" = '${id}'